package com.trkj.dao.wxy;

import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.ExamSite;

public interface ExamSiteDao extends CrudRepository<ExamSite, Long> {
	//多表查询分页
	@Query("select s from ExamSite s")
	public List<ExamSite> queryByExamSiteKsxcgl(Pageable p);
	//多表查询分页
	@Query("select s  from ExamSite s where to_char(s.testTime,'yyyy-mm-dd')=to_char(sysdate,'yyyy-mm-dd')")
	public List<ExamSite> queryByExamSiteJrks(Pageable p);
}
